select geometry::Point(1, 1, 0).STAsBinary()
select geometry::Point(1, 1, 0)
select geometry::STGeomFromText('POINT(1 2 1)', 0);
select geometry::STGeomFromText('POINT(1 2 1 2)', 0);

--0x01 01000000  000000000000F03F 000000000000F03F
--0x00000000010C 000000000000F03F 000000000000F03F
--0x00000000010D 000000000000F03F 0000000000000040 000000000000F03F
--0x00000000010F 000000000000F03F 0000000000000040 000000000000F03F 0000000000000040


select geometry::STMPointFromText('MULTIPOINT ((100 100), (200 200))', 0);


select geometry::STLineFromText('LINESTRING (0 0, 1 1)', 0).STAsBinary()
select geometry::STLineFromText('LINESTRING (0 0, 1 0)', 0)
select geometry::STLineFromText('LINESTRING (0 0, 1 0 0)', 0)
select geometry::STLineFromText('LINESTRING (0 0, 1 1 1 1)', 0)

--0x01 02000000 02000000 0000000000000000 0000000000000000 000000000000F03F 000000000000F03F
--0x000000000114 0000000000000000 0000000000000000 000000000000F03F 000000000000F03F
--0x000000000115 0000000000000000 0000000000000000 000000000000F03F 000000000000F03F 000000000000F8FF 0000000000000000
--0x000000000117 0000000000000000 0000000000000000 000000000000F03F 000000000000F03F 000000000000F8FF 000000000000F03F 000000000000F8FF 000000000000F03F


select geometry::STLineFromText('LINESTRING (0 0, 1 1, 2 2)', 0).STAsBinary()
select geometry::STLineFromText('LINESTRING (0 0, 1 0, 2 2, 4 4, 5 5)', 0)
select geography::STLineFromText('LINESTRING (0 0, 1 0, 2 2)', 4326)
select geometry::STLineFromText('LINESTRING (0 0, 1 1, 2 2 0)', 0)
select geometry::STLineFromText('LINESTRING (0 0, 1 1, 2 2 0 0)', 0)

--0x01020000000300000000000000000000000000000000000000000000000000F03F000000000000F03F 0000000000000040 0000000000000040
--0x00000000 0104 03000000 0000000000000000 0000000000000000 000000000000F03F 0000000000000000 0000000000000040 0000000000000040 01000000010000000001000000FFFFFFFF0000000002
--0xE6100000 0104 03000000 0000000000000000 0000000000000000 0000000000000000 000000000000F03F 0000000000000040 0000000000000040 01000000010000000001000000FFFFFFFF0000000002
--0x00000000 0105 03000000 0000000000000000 0000000000000000 000000000000F03F 000000000000F03F 0000000000000040 0000000000000040 000000000000F8FF 000000000000F8FF 0000000000000000 01000000010000000001000000FFFFFFFF0000000002
--0x00000000 0107 03000000 0000000000000000 0000000000000000 000000000000F03F 000000000000F03F 0000000000000040 0000000000000040 000000000000F8FF 000000000000F8FF 0000000000000000 000000000000F8FF 000000000000F8FF 0000000000000000 01000000010000000001000000FFFFFFFF0000000002

select geometry::STLineFromText('LINESTRING (0 0, 1 1, 2 2, 0 0, 5 5, 1 1)', 0)
--0x0000000001030500000000000000000000000000000000000000000000000000F03F000000000000F03F000000000000004000000000000000400000000000000000000000000000000000000000000014400000000000001440000000000000F8FF000000000000F8FF000000000000F8FF000000000000F8FF000000000000F03F000000000000F8FF000000000000F8FF000000000000F8FF000000000000F8FF000000000000F03F01000000010000000001000000FFFFFFFF0000000002
--0x0000000001000600000000000000000000000000000000000000000000000000F03F000000000000F03F000000000000004000000000000000400000000000000000000000000000000000000000000014400000000000001440000000000000F03F000000000000F03F01000000010000000001000000FFFFFFFF0000000002

select geometry::STPolyFromText('POLYGON ((0 0, 10 0, 10 10, 0 10, 0 11, 0 0))', 0);
--0x00000000 0104 05000000 0000000000000000 0000000000000000 0000000000002440 0000000000000000 0000000000002440 0000000000002440 0000000000000000 0000000000002440 0000000000000000 0000000000000000 01000000 0200000000 01000000 FFFFFFFF 0000000003
--0xE6100000 0104 05000000000000000000000000000000000000000000000000002440000000000000000000000000000024400000000000002440000000000000000000000000000024400000000000000000000000000000000001000000020000000001000000FFFFFFFF0000000003


select geometry::STPolyFromText('POLYGON ((0 0, 10 0, 10 10, 0 10, 0 0), (2 2, 2 4, 4 4, 4 2, 2 2 ), (2 2, 2 4, 4 4, 4 2, 2 2 ))', 0).STAsText()
--0x000000000104 0A00000000000000000000000000000000000000000000000000244000000000000000000000000000002440000000000000244000000000000000000000000000002440000000000000000000000000000000000000000000000040000000000000004000000000000000400000000000001040000000000000104000000000000010400000000000001040000000000000004000000000000000400000000000000040020000000200000000000500000001000000FFFFFFFF0000000003


select geometry::STLineFromText('LINESTRING (0 0, 10 0, 10 10, 0 10, 0 0, 2 2, 2 4, 4 4, 4 2, 2 2 )', 0).STAsText()
--0x000000000104 0A0000000000000000000000000000000000000000000000000024400000000000000000000000000000244000000000000024400000000000000000000000000000244000000000000000000000000000000000000000000000004000000000000000400000000000000040000000000000104000000000000010400000000000001040000000000000104000000000000000400000000000000040000000000000004001000000010000000001000000FFFFFFFF0000000002


select geometry::STMPolyFromText('MULTIPOLYGON (((5 5, 10 5, 10 10, 11 11, 5 5), (2 2, 2 4, 4 4, 4 2, 2 2 )), ((1 1, 100 10, 200 200, 30 30, 10 10, 11 11,  1 1 ), (1 1, 2 4, 4 4, 4 2, 1 1 )))', 0);

--0x0000000001001600000000000000000014400000000000001440000000000000244000000000000014400000000000002440000000000000244000000000000026400000000000002640000000000000144000000000000014400000000000000040000000000000004000000000000000400000000000001040000000000000104000000000000010400000000000001040000000000000004000000000000000400000000000000040000000000000F03F000000000000F03F00000000000059400000000000002440000000000000694000000000000069400000000000003E400000000000003E400000000000002440000000000000244000000000000026400000000000002640000000000000F03F000000000000F03F000000000000F03F000000000000F03F000000000000004000000000000010400000000000001040000000000000104000000000000010400000000000000040000000000000F03F000000000000F03F0400000002000000000005000000020A000000001100000003000000FFFFFFFF0000000006000000000000000003000000000200000003


SELECT *, '#FF49A9CC' as FillColor, geometry::Point(x, y, 0).STBuffer(0.3) As sig
FROM ( VALUES
  (01,16),(01,17),(01,18),(01,19),(01,20),(01,21),(01,22),(01,23),(02,14),(02,15),
  (02,24),(02,30),(02,31),(03,13),(03,23),(03,24),(03,25),(03,26),(03,27),(03,28),
  (03,29),(03,32),(03,33),(03,34),(03,35),(04,13),(04,36),(05,10),(05,11),(05,12),
  (05,37),(06,08),(06,09),(06,23),(06,38),(07,07),(07,23),(07,39),(08,06),(08,24),
  (08,25),(08,39),(09,05),(09,23),(09,24),(09,25),(09,26),(09,40),(10,04),(10,23),
  (10,24),(10,25),(10,26),(10,39),(11,03),(11,25),(11,39),(12,02),(12,10),(12,25),
  (12,39),(13,01),(13,39),(14,01),(14,39),(15,01),(15,10),(15,14),(15,38),(16,02),
  (16,07),(16,13),(16,14),(16,15),(16,17),(16,18),(16,19),(16,20),(16,21),(16,22),
  (16,39),(17,02),(17,10),(17,14),(17,15),(17,16),(17,17),(17,18),(17,19),(17,20),
  (17,21),(17,22),(17,23),(17,24),(17,25),(17,38),(18,02),(18,08),(18,10),(18,14),
  (18,15),(18,16),(18,17),(18,18),(18,24),(18,25),(18,38),(19,03),(19,08),(19,10),
  (19,15),(19,25),(19,26),(19,38),(20,03),(20,10),(20,11),(20,24),(20,25),(20,26),
  (20,38),(21,04),(21,11),(21,23),(21,24),(21,25),(21,26),(21,38),(21,39),(22,05),
  (22,06),(22,23),(22,24),(22,25),(22,38),(22,39),(23,07),(23,08),(23,22),(23,23),
  (23,24),(23,38),(23,39),(23,40),(24,09),(24,10),(24,11),(24,12),(24,13),(24,22),
  (24,23),(24,24),(24,37),(24,38),(24,39),(25,14),(25,22),(25,23),(25,24),(25,25),
  (25,37),(25,38),(25,39),(26,15),(26,16),(26,22),(26,23),(26,24),(26,25),(26,26),
  (26,27),(26,28),(26,29),(26,30),(26,31),(26,37),(26,38),(26,39),(27,17),(27,18),
  (27,19),(27,20),(27,23),(27,24),(27,27),(27,28),(27,29),(27,30),(27,31),(27,32),
  (27,33),(27,34),(27,35),(27,36),(27,37),(27,38),(27,39),(28,21),(28,22),(28,26),
  (28,27),(28,28),(28,29),(28,30),(28,31),(28,32),(28,33),(28,34),(28,35),(28,36),
  (28,37),(28,38),(29,26),(29,27),(29,28),(29,29),(29,30),(29,31),(29,32),(29,33),
  (29,34),(29,35),(29,36),(29,37),(29,38),(29,39),(30,26),(30,28),(30,31),(30,32),
  (30,33),(30,34),(30,35),(30,36),(30,37),(31,28),(31,29) ) AS Coordinates(x, y);